home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 December / Chip_2003-12_cd1.bin / program / ctenari / ShiCola / CodePad37.exe / $INSTDIR / Syntax Definitions / sql_ms.def < prev    next >
Encoding:
Text File  |  2003-10-17  |  11.0 KB  |  269 lines
  1. object TPersHolder
  2.   P.Name = 'SQL (MS SQL)'
  3.   P.Extensions.Strings = (
  4.     'SQL files (*.sql)|*.sql')
  5.   P.SyntaxBlocks = <
  6.     item
  7.       Name = 'Default'
  8.       ID = 0
  9.       FIText = 0
  10.       FIIntNum = 1
  11.       FIFloatNum = 2
  12.       FIHexNum = 3
  13.       FISymbol = 8
  14.       FIIdentifier = 6
  15.       UseSymbols = True
  16.       UseComments = True
  17.       UseSingleLineComments = True
  18.       UseMultiLineComments = True
  19.       UseStrings = True
  20.       UseSingleLineStrings = True
  21.       UseKeywords = True
  22.       BlockDelimiters = <>
  23.       SingleLineCommentDelimiters = <
  24.         item
  25.           FontID = 4
  26.           LeftDelimiter = '--'
  27.         end>
  28.       MultiLineCommentDelimiters = <
  29.         item
  30.           FontID = 4
  31.           LeftDelimiter = '/*'
  32.           RightDelimiter = '*/'
  33.         end>
  34.       SingleLineStringDelimiters = <
  35.         item
  36.           FontID = 5
  37.           LeftDelimiter = #39
  38.           RightDelimiter = #39
  39.         end>
  40.       KeywordSets = <
  41.         item
  42.           FontID = 7
  43.           Name = 'reserved'
  44.           Keywords = 
  45.             'ABSOLUTE,ACTION,ADD,ADMIN,AFTER,AGGREGATE,ALIAS,ALL,ALLOCATE,ALT' +
  46.             'ER,ANY,ARE,ARRAY,AS,ASC,ASSERTION,AT,AUTHORIZATION,BACKUP,BEFORE' +
  47.             ',BEGIN,BLOB,BOOLEAN,BOTH,BREADTH,BREAK,BROWSE,BULK,BY,CALL,CASCA' +
  48.             'DE,CASCADED,CASE,CAST,CATALOG,CLASS,CLOB,CLOSE,CLUSTERED,COALESC' +
  49.             'E,COLLATE,COLLATION,COLUMN,COMMIT,COMPLETION,COMPUTE,CONNECT,CON' +
  50.             'NECTION,CONSTRAINT,CONSTRAINTS,CONSTRUCTOR,CONSTRUCTOR,CONTAINS,' +
  51.             'CONTAINSTABLE,CONTINUE,CONVERT,CORRESPONDING,CREATE,CROSS,CUBE,C' +
  52.             'URRENT,CURRENT_DATE,CURRENT_PATH,CURRENT_ROLE,CURRENT_TIME,CURRE' +
  53.             'NT_USER,CURSOR,CYCLECURRENT_TIMESTAMP,DATA,DATABASE,DATE,DBCC,DE' +
  54.             'ALLOCATE,DEC,DECLARE,DEFAULT,DEFERRABLE,DEFERRED,DELETE,DENY,DEP' +
  55.             'TH,DEREF,DESC,DESCRIBE,DESCRIPTOR,DESTROY,DESTRUCTOR,DETERMINIST' +
  56.             'IC,DIAGNOSTICS,DICTIONARY,DISCONNECT,DISK,DISTINCT,DISTRIBUTED,D' +
  57.             'OMAIN,DOUBLE,DROP,DUMMY,DUMP,DYNAMICEACH,ELSE,END,END-EXEC,EQUAL' +
  58.             'S,ERRLVL,ESCAPE,EVERY,EXCEPT,EXCEPTION,EXEC,EXECUTE,EXIT,EXTERNA' +
  59.             'LFALSE,FETCH,FILE,FILLFACTOR,FIRST,FOR,FOREIGN,FOUND,FREE,FREETE' +
  60.             'XT,FREETEXTTABLE,FROM,FULL,FUNCTION,GENERAL,GET,GLOBAL,GO,GOTO,G' +
  61.             'RANT,GROUP,GROUPING,HAVING,HOLDLOCK,HOST,HOUR,CHARACTER,CHECK,CH' +
  62.             'ECKPOINT,IDENTITY,IDENTITY_INSERT,IDENTITYCOL,IF,IGNORE,IMEDIATE' +
  63.             ',INDEX,INITIALIZE,INITIALLY,INNER,INOUT,INPUT,INSERT,INTEGER,INT' +
  64.             'ERSECT,INTERVAL,INTO,IS,ISOLATION,ITERATEJOIN,KEY,KILL,LANGUAGE,' +
  65.             'LARGE,LAST,LATERAL,LEADING,LEFT,LESS,LEVEL,LIKE,LIMIT,LINENO,LOA' +
  66.             'D,LOCAL,LOCALTIME,LOCALTIMESTAMP,LOCATOR,MAP,MATCH,MIDIFIES,MINU' +
  67.             'TE,MODIFY,MODULE,NAMES,NATIONAL,NATURAL,NCLOB,NEW,NEXT,NCHAR,NO,' +
  68.             'NOCHECK,NONCLUSTERED,NONE,NULLIF,OBJECT,OF,OFF,OFFSETS,OLD,ON,ON' +
  69.             'LY,OPEN,OPENDATASOURCE,OPENQUERY,OPENROWSET,OPENXML,OPERATION,OP' +
  70.             'TION,ORDER,ORDINALITY,OUT,OUTER,OUTPUT,OVER,PAD,PARAMETER,PARAME' +
  71.             'TERS,PARTIAL,PATH,PERCENT,PLAN,POSTFIX,PRECISION,PREFIX,PREORDER' +
  72.             ',PREPARE,PRESERVE,PRIMARY,PRINT,PRIOR,PRIVILEGES,PROC,PROCEDURE,' +
  73.             'PUBLIC,RAISERROR,READ,READS,READTEXT,RECONFIGURE,RECURSIVE,REF,R' +
  74.             'EFERENCES,REFERENCING,RELATIVE,REPLICATION,RESTORE,RESTRICT,RESU' +
  75.             'LT,RETURN,RETURNS,REVOKE,RIGHT,ROLE,ROLLBACK,ROLLUP,ROUTAIN,ROW,' +
  76.             'ROWCOUNT,ROWGUIDCOL,ROWS,RULESAVE,SAVEPOINT,SCOPE,SCROLL,SEARCH,' +
  77.             'SECOND,SECTION,SELECT,SEQUENCE,SESSION,SESSION_USER,SET,SETS,SET' +
  78.             'USER,SHUTDOWN,SCHEMA,SIZE,SOME,SPACE,SPECIFIC,SPECIFICTYPE,SQL,S' +
  79.             'QLEXCEPTION,SQLSTATE,SQLWARNING,START,STATE,STATEMENT,STATIC,STA' +
  80.             'TISTICS,STRUCTURE,SYSTEM_USER,TABLE,TEMPORARY,TERMINATE,TEXTSIZE' +
  81.             ',THAN,THEN,TIME,TIMEZONE_HOUR,TIMEZONE_MINUTE,TO,TOP,TRAILING,TR' +
  82.             'AN,TRANSACTION,TRANSLATION,TREAT,TRIGGER,TRUE,TRUNCATE,TSEQUAL,U' +
  83.             'NDER,UNION,UNIQUE,UNKNOWN,UNNEST,UPDATE,UPDATETEXT,USAGE,USE,USE' +
  84.             'R,USING,VALUE,VALUES,VARIABLE,VARYING,VIEW,WAITFOR,WHEN,WHENEVER' +
  85.             ',WHERE,WHILE,WITH,WITHOUT,WORK,WRITE,WRITETEXT,ZONE'
  86.         end
  87.         item
  88.           FontID = 9
  89.           Name = 'data types'
  90.           Keywords = 
  91.             'bigint,binary,bit,datetime,decimal,float,char,image,int,money,nc' +
  92.             'har,ntext,numeric,nvarchar,real,smalldatetime,smallint,smallmone' +
  93.             'y,sql_variant,text,timestamp,tinyint,uniqueindentifier,varbinary' +
  94.             ',varchar'
  95.         end
  96.         item
  97.           FontID = 10
  98.           Name = 'common objects'
  99.           Keywords = 
  100.             '@@CONNECTIONS,@@CPU_BUSY,@@CURSOR_ROWS,@@DATEFIRST,@@DBTS,@@ERRO' +
  101.             'R,@@FETCH_STATUS,@@IDENTITY,@@IDLE,@@IO_BUSY,@@LANGID,@@LANGUAGE' +
  102.             ',@@LOCK_TIMEOUT,@@MAX_CONNECTIONS,@@MAX_PRECISION,@@NESTLEVEL,@@' +
  103.             'OPTIONS,@@PACK_RECEIVED,@@PACKET_ERRORS,@@PROCID,@@REMSERVER,@@R' +
  104.             'OWCOUNT,@@SERVERNAME,@@SERVICENAME,@@SPID,@@TEXTSIZE,@@TIMETICKS' +
  105.             ',@@TOTAL_ERRORS,@@TOTAL_READ,@@TOTAL_WRITE,@@TRANCOUNT,@@VERSION' +
  106.             ',@PACK_SENT,ABS,ACOS,APP_NAME,ASCII,ASIN,ATAN,ATN2,AVG,BINARY_CH' +
  107.             'ECKSUM,CASE,CAST,CEILING,COALESCE,COL_LENGTH,COL_NAME,COLLATIONP' +
  108.             'ROPERTY,COLUMNPROPERTY,CONTAINSTABLE,CONVERT,COS,COT,COUNT,COUNT' +
  109.             '_BIG,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR_STATUS,DATABASEPROPER' +
  110.             'TY,DATABASEPROPERTYEX,DATALENGTH,DATE_ADD,DATE_DIFF,DATENAME,DAT' +
  111.             'EPART,DAY,DB_ID,DB_NAME,DEGREES,DIFFERENCE,EXP,FILE_ID,FILE_NAME' +
  112.             ',FILEGROUP_ID,FILEGROUP_NAME,FILEGROUPPROPERTY,FILEPROPERTY,FLOO' +
  113.             'R,fn_helpcollations,fn_listextendedproperty,fn_servershareddrive' +
  114.             's,fn_trace_geteventinfo,fn_trace_getfilterinfo,fn_trace_getinfo,' +
  115.             'fn_trace_gettable,fn_virtualfilestats,fn_virtualservernodes,FORM' +
  116.             'ATMESSAGE,FREETEXTTABLE,FULLTEXTCATALOGPROPERTY,FULLTEXTSERVICEP' +
  117.             'ROPERTY,GETANSINULL,GETDATE,GETUTCDATE,GROUPING,HAS_DBACCESS,HOS' +
  118.             'T_ID,HOST_NAME,CHARINDEX,CHECKSUM,CHECKSUM_AGG,IDENT_INCR,IDENT_' +
  119.             'SEED,IDENTITY,INDEX_COL,INDEXKEY_PROPERTY,INDEXPROPERTY,IS_MEMBE' +
  120.             'R,IS_SVRROLEMEMBER,ISDATE,ISNULL,ISNUMERIC,LEFT,LEN,LOG,LOG10,LO' +
  121.             'WER,LTRIM,MAX,MIN,MONTH,NEWID,NULLIF,OBJECT_ID,OBJECT_NAME,OBJEC' +
  122.             'TPROPERTY,OPENDATASOURCE,OPENQUERY,OPENROWSET,OPENXML,PARESNAME,' +
  123.             'PATINDEX,PERMISSIONS,PI,POWER,QUOTENAME,RADIANS,RAND,REPLACE,REP' +
  124.             'LICATE,REVERSE,RIGHT,ROUND,ROWCOUNT_BIG,RTRIM,SCOPE_IDENTITY,SER' +
  125.             'VERPROPERTY,SESSION_USER,SESSIONPROPERTY,SIGN,SIN,SOUNDEX,SPACE,' +
  126.             'SQL_VARIANT_PROPERTY,SQRT,SQUARE,STDEV,STDEVP,STR,STUFF,SUBSTRIN' +
  127.             'G,SUM,SUSER_ID,SUSER_NAME,SUSER_SID,SUSER_SNAME,TAN,TEXTPTR,TEXT' +
  128.             'VALID,TYPEPROPERTY,UNICODE,UPPER,USER,USER_ID,USER_NAME,VAR,VARP' +
  129.             ',YEAR'
  130.         end
  131.         item
  132.           FontID = 11
  133.           Name = 'logical'
  134.           Keywords = 'AND,BETWEEN,exists,IN,NOT,NULL,OR'
  135.         end
  136.         item
  137.           FontID = 13
  138.           Name = 'system tables'
  139.           Keywords = 
  140.             'sysaltfiles,syscacheobjects,syscolumns,syscomments,sysconfigures' +
  141.             ',syscurconfigs,syscursorcolumns,syscursorrefs,syscursors,syscurs' +
  142.             'ortables,sysdatabases,sysdepends,sysdevices,sysfilegroups,sysfil' +
  143.             'es,sysfiles1,sysforeignkeys,sysfulltextcatalogs,sysfulltextnotif' +
  144.             'y,syscharsets,sysindexes,sysindexkeys,syslanguages,syslockinfo,s' +
  145.             'yslocks,sysmembers,sysmessages,sysobjects,sysperfinfo,syspermiss' +
  146.             'ions,sysprocesses,sysproperties,sysprotects,sysreferences,SYSREM' +
  147.             'OTE_CATALOGS,SYSREMOTE_COLUMN_PRIVILEGES,SYSREMOTE_COLUMNS,SYSRE' +
  148.             'MOTE_FOREIGN_KEYS,SYSREMOTE_INDEXES,SYSREMOTE_PRIMARY_KEYS,SYSRE' +
  149.             'MOTE_PROVIDER_TYPES,SYSREMOTE_SCHEMATA,SYSREMOTE_STATISTICS,SYSR' +
  150.             'EMOTE_TABLE_PROVILEGES,SYSREMOTE_TABLES,SYSREMOTE_VIEWS,sysserve' +
  151.             'rs,systypes,sysusers,sysxlogins'
  152.         end>
  153.     end>
  154.   P.FontTable = <
  155.     item
  156.       FontID = 0
  157.       GlobalAttrID = 'Whitespace'
  158.       Font.Charset = DEFAULT_CHARSET
  159.       Font.Color = clBlack
  160.       Font.Height = -13
  161.       Font.Name = 'Courier New'
  162.       Font.Style = []
  163.     end
  164.     item
  165.       FontID = 1
  166.       GlobalAttrID = 'Integer'
  167.       Font.Charset = DEFAULT_CHARSET
  168.       Font.Color = clGreen
  169.       Font.Height = -13
  170.       Font.Name = 'Courier New'
  171.       Font.Style = []
  172.     end
  173.     item
  174.       FontID = 2
  175.       GlobalAttrID = 'Float'
  176.       Font.Charset = DEFAULT_CHARSET
  177.       Font.Color = clGreen
  178.       Font.Height = -13
  179.       Font.Name = 'Courier New'
  180.       Font.Style = []
  181.     end
  182.     item
  183.       FontID = 3
  184.       GlobalAttrID = 'Integer'
  185.       Font.Charset = DEFAULT_CHARSET
  186.       Font.Color = clGreen
  187.       Font.Height = -13
  188.       Font.Name = 'Courier New'
  189.       Font.Style = []
  190.     end
  191.     item
  192.       FontID = 4
  193.       Font.Charset = DEFAULT_CHARSET
  194.       Font.Color = clTeal
  195.       Font.Height = -13
  196.       Font.Name = 'Courier New'
  197.       Font.Style = [fsItalic]
  198.     end
  199.     item
  200.       FontID = 5
  201.       Font.Charset = DEFAULT_CHARSET
  202.       Font.Color = clRed
  203.       Font.Height = -13
  204.       Font.Name = 'Courier New'
  205.       Font.Style = []
  206.     end
  207.     item
  208.       FontID = 6
  209.       GlobalAttrID = 'System Variable'
  210.       Font.Charset = DEFAULT_CHARSET
  211.       Font.Color = clBlue
  212.       Font.Height = -13
  213.       Font.Name = 'Courier New'
  214.       Font.Style = []
  215.     end
  216.     item
  217.       FontID = 7
  218.       GlobalAttrID = 'Reserved words'
  219.       Font.Charset = DEFAULT_CHARSET
  220.       Font.Color = clBlue
  221.       Font.Height = -13
  222.       Font.Name = 'Courier New'
  223.       Font.Style = []
  224.     end
  225.     item
  226.       FontID = 8
  227.       GlobalAttrID = 'Delimiters'
  228.       Font.Charset = DEFAULT_CHARSET
  229.       Font.Color = clBlack
  230.       Font.Height = -13
  231.       Font.Name = 'Courier New'
  232.       Font.Style = []
  233.     end
  234.     item
  235.       FontID = 9
  236.       GlobalAttrID = 'Reserved words'
  237.       Font.Charset = DEFAULT_CHARSET
  238.       Font.Color = clBlue
  239.       Font.Height = -13
  240.       Font.Name = 'Courier New'
  241.       Font.Style = []
  242.     end
  243.     item
  244.       FontID = 10
  245.       Font.Charset = DEFAULT_CHARSET
  246.       Font.Color = clFuchsia
  247.       Font.Height = -13
  248.       Font.Name = 'Courier New'
  249.       Font.Style = []
  250.     end
  251.     item
  252.       FontID = 11
  253.       Font.Charset = DEFAULT_CHARSET
  254.       Font.Color = clGray
  255.       Font.Height = -13
  256.       Font.Name = 'Courier New'
  257.       Font.Style = []
  258.     end
  259.     item
  260.       FontID = 13
  261.       Font.Charset = DEFAULT_CHARSET
  262.       Font.Color = clGreen
  263.       Font.Height = -13
  264.       Font.Name = 'Courier New'
  265.       Font.Style = []
  266.     end>
  267.   P.SyntaxVersion = 3
  268. end
  269.